<?php

/**
 * This is the model class for table "menu".
 *
 * The followings are the available columns in table 'menu':
 * @property string $id
 * @property string $root
 * @property string $lft
 * @property string $rgt
 * @property integer $level
 * @property string $name
 * @property string $link
 * @property integer $order
 */
class Menu extends CActiveRecord {

    public $typeMenu;
    public $search;
    
    /**
     * @return string the associated database table name
     */
    public function tableName() {
        return 'menu';
    }

    /**
     * @return array validation rules for model attributes.
     */
    public function rules() {
        // NOTE: you should only define rules for those attributes that
        // will receive user inputs.
        return array(
            array('name', 'required'),
            array('level, orders', 'numerical', 'integerOnly' => true),
            array('root, lft, rgt', 'length', 'max' => 10),
            array('name', 'length', 'max' => 255),
            array('link,parents', 'safe'),
            // The following rule is used by search().
            // @todo Please remove those attributes that should not be searched.
            array('id, root, lft, rgt, level, name, link, order', 'safe', 'on' => 'search'),
        );
    }

    /**
     * @return array relational rules.
     */
    public function relations() {
        // NOTE: you may need to adjust the relation name and the related
        // class name for the relations automatically generated below.
        return array(
        );
    }

    /**
     * @return array customized attribute labels (name=>label)
     */
    public function attributeLabels() {
        return array(
            'id' => 'ID',
            'root' => 'Root',
            'lft' => 'Lft',
            'rgt' => 'Rgt',
            'level' => 'Level',
            'name' => 'Name',
            'link' => 'Link',
            'order' => 'Order',
            'typeMenu' => 'loại link'
        );
    }

    /**
     * Retrieves a list of models based on the current search/filter conditions.
     *
     * Typical usecase:
     * - Initialize the model fields with values from filter form.
     * - Execute this method to get CActiveDataProvider instance which will filter
     * models according to data in model fields.
     * - Pass data provider to CGridView, CListView or any similar widget.
     *
     * @return CActiveDataProvider the data provider that can return the models
     * based on the search/filter conditions.
     */
    public function search() {
        // @todo Please modify the following code to remove attributes that should not be searched.

        $criteria = new CDbCriteria;

        $criteria->compare('id', $this->id, true);
        $criteria->compare('root', $this->root, true);
        $criteria->compare('lft', $this->lft, true);
        $criteria->compare('rgt', $this->rgt, true);
        $criteria->compare('level', $this->level);
        $criteria->compare('name', $this->name, true);
        $criteria->compare('link', $this->link, true);
        $criteria->compare('order', $this->order);

        return new CActiveDataProvider($this, array(
            'criteria' => $criteria,
        ));
    }

    /**
     * Returns the static model of the specified AR class.
     * Please note that you should have this exact method in all your CActiveRecord descendants!
     * @param string $className active record class name.
     * @return Menu the static model class
     */
    public static function model($className=__CLASS__) {
        return parent::model($className);
    }

    /**
     * add behaviors
     * @return type 
     */
    public function behaviors() {
        return array(
            'nestedSetBehavior' => array(
                'class' => 'NestedSetBehavior',
                'leftAttribute' => 'lft',
                'rightAttribute' => 'rgt',
                'levelAttribute' => 'level',
                'hasManyRoots' => true
            ),
        );
    }
    
    /**
     * get list Menu
     */
    public static function getListMenu($parent,$stop = null){
        $result = array();
        self::loopNode($result, $parent, $stop,"");
        return $result;
    }
    
    /**
     *
     * @param type $result
     * @param type $parent
     * @param type $stop
     * @return type 
     */
    public static function loopNode(&$result,$parent,$stop,$prefix,$separ = " - -"){
        if($stop != null && $parent == $stop)
            return true;
        else{
            $Menu = self::model()->findByPk($parent);
            $result[$Menu->id] = $prefix." ".$Menu->name;
            foreach($Menu->children()->findAll() as $item){
                self::loopNode($result, $item->id, $stop,$prefix.$separ,$separ);
            }
        }
    }

}
